﻿USE [SampleThreeTierArchitecture]
GO

/****** Object:  StoredProcedure [dbo].[usp_GetParticularBookDetails]    Script Date: 1/15/2015 7:02:06 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


create procedure [dbo].[usp_GetParticularBookDetails] 
@bookId int
as
select BookId, BookName, AuthorName, Genre
from BookDetails
where BookId = @bookId

GO


